Perpetual Inventory Control
Use this template to record the inventory status of a given part or item. Because there are relatively few formulas, this template can be used on paper as well as electronically. Enter the sheet number. The amount that should be carried forward to the next sheet and the next sheet number are at the bottom of the template. To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next.
Perpetual Inventory Control
ITEM ITEM NUMBER SHEET NUMBER ORDERED
DATE ORDER NO VENDOR QTY DATE
RECEIVED
QTY BACKORDER DUE DATE DATE
SOLD
ORDER NO QTY BALANCE COMMENTS BALANCE FORWARD
CARRIED TO NEXT SHEET